VS2008: Simple DataGridView not populating

This is a multipart message in MIME format.

------=_NextPart_000_0034_01C893F7.D28F7000
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Context:



Windows Vista x64

PostgreSQL 8.3 (server on localhost)

psql-obdc v8.03.01

Visual Studio 2008 (VS2008)



Problem:



I created a System DSN using the Data Sources (ODBC) administration tool
located in \SysWOW64\odbcad32.exe. Note that this is *not* the same
one you get from Control Panel ->Administrative Tools (that one is in
/system32 and can apparently only manage 64 bit DSNs). Test
successful.



In VS2008, add new Data Source picking up one table from the DSN just
created. On Data Sources tab, can rightclick the table and "Preview
Data"...works fine in the IDE, successfully retrieving data from the
database.



Create a trivial Windows Forms Application with a DataGridView [DGV]
control. No code-behind...just connect the DGV Data Source to the DSN table.
Run the application...no data in DGV.



Do exact same thing except with Northwind DSN (sample SQL Server database,
not using PostgreSQL or psql-odbc)...run app...DGV populates just fine.



Analysis:



Enabling mylog in psql-odbc doesn't give much information. If I log the
VS2008 IDE interaction with the DSN (e.g., when using "Preview Data")...it
all looks good.



If I compile the app and execute it with mylog enabled...nothing in the log
file except the intialization from turning on logging. That is, the app
never finds the DSN, and in fact gives an error to that effect:



[ERROR] [IM002] [Microsoft] [ODBC Driver Manager] Data source name not found
and no default driver specified.



So it appears that this may be an x64 issue...The application can't find the
DSN probably because there is no entry for it in
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI...instead the entry is in the
redirected key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI but
it's not getting redirected there.



I can't understand why the VS2008 IDE can interact with the DSN just fine,
but the simple app can't find it. Perhaps there's a "target platform" I have
to specify? Any ideas?





Charles S. Henkel

Henkel Technical Computing, LLC

9917 Laurel Springs Ave

Las Vegas, NV 89134




------=_NextPart_000_0034_01C893F7.D28F7000
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

Re: VS2008: Simple DataGridView not populating

This is a multi-part message in MIME format.


------_=_NextPart_001_01C89436.C9A4F2C7
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

One question If you are using VS 2008 and presumably NET Framework,=
why are you not using the PostgreSQL ADONET driver instead of ODB=
C? http://pgfoundryorg/projects/npgsql =
________________________________ From: pgsql-odbc-owner@po=
stgresqlorg [mailto:pgsql-odbc-owner@postgresqlor g] On Behalf Of=
Charles S Henkel Sent: Tuesday, April 01, 2008 3:57 PM To: pg=
sql-odbc@postgresqlorg Subject: [ODBC] VS2008: Simple DataGridView =
not populating Context: Wind=
ows Vista x64 PostgreSQL 83 (server on localhost) =
psql-obdc v80301 Visual Studio 2008 (VS2008) =
Problem: I created a System DSN using t=
he Data Sources (ODBC) administration tool located in \SysWOW6=
4\odbcad32exe Note that this is *not* the same one you get from =
Control Panel ->Administrative Tools (that one is in /system32=
and can apparently only manage 64 bit DSNs) Test successful. =
=0A In VS2008, add new Data Source picking up one table f=
rom the DSN just created On Data Sources tab, can rightclick the t=
able and "Preview Data"..works fine in the IDE, successfully re=
trieving data from the database. =0A Create a tr=
ivial Windows Forms Application with a DataGridView [DGV] control N=
o code-behind..just connect the DGV Data Source to the DSN tabl=
e Run the application..no data in DGV. =0A =
Do exact same thing except with Northwind DSN (sample SQL Server datab=
ase, not using PostgreSQL or psql-odbc)..run app..DGV populat=
es just fine. =0A Analysis: =
Enabling mylog in psql-odbc doesn't give much information If I log=
the VS2008 IDE interaction with the DSN (eg, when using "Previe=
w Data")..it all looks good If I co=
mpile the app and execute it with mylog enabled..nothing in the=0D=
=0Alog file except the intialization from turning on logging That is, th=
e app never finds the DSN, and in fact gives an error to that effect:=
[ERROR] [IM002] [Microsoft] [ODBC Driver Manager] =
Data source name not found and no default driver specified. =
=0A So it appears that this may be an x64 issue..The app=
lication can't find the DSN probably because there is no entry for it =
in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI.. instead the ent=
ry is in the redirected key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\OD=
BC\ODBCINI but it's not getting redirected there. =0A =0D=
=0AI can't understand why the VS2008 IDE can interact with the DSN ju=
st fine, but the simple app can't find it Perhaps there's a "target=
platform" I have to specify? Any ideas? =0D=
=0ACharles S Henkel Henkel Technical Computing, LLC=0D=
=0A9917 Laurel Springs Ave Las Vegas, NV 89134 =0D=
=0A ------------------------------------ ----- =
The substance of this message, including any attachments, may be=0Aconfiden=
tial, legally privileged and/or exempt from disclosure=0Apursuant to Massac=
husetts law It is intended solely for the addressee If you recei=
ved this in error, please=0Acontact the sender and delete the material from=
any computer. =0A
------_=_NextPart_001_01C89436.C9A4F2C7
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns=3D"http://wwww3org/TR/REC-html40" xmlns:v =3D "urn:schem=
as-microsoft-com:vml" xmlns:o =3D "urn:schemas-microsoft-com:office:o=
ffice" xmlns:w =3D "urn:schemas-microsoft-com:office:word" xmlns:m =
=3D "http://schemasmicrosoftcom/office/2004/12/omml" >=0D=
=0A "> =0D=
=0A =3DEN-US vLink=3Dpurple link=3Dblue>